CREATE TABLE DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE
(
    FINAL_SIGN_NETWORK_CODE NVARCHAR2(100),
    FINAL_SIGN_NETWORK_NAME NVARCHAR2(100),
    END_AGENT_CODE          NVARCHAR2(100),
    END_AGENT_NAME          NVARCHAR2(100),
    END_PROVIDER_ID         NVARCHAR2(100),
    END_PROVIDER_NAME       NVARCHAR2(100),
    NEED_SIGN_COUNT_1D      NUMBER,
    RETENTION_COUNT_1D      NUMBER,
    NEED_SIGN_COUNT_2D      NUMBER,
    RETENTION_COUNT_2D      NUMBER,
    NEED_SIGN_COUNT_3D      NUMBER,
    RETENTION_COUNT_3D      NUMBER,
    NEED_SIGN_COUNT_5D      NUMBER,
    RETENTION_COUNT_5D      NUMBER,
    NEED_SIGN_COUNT_7D      NUMBER,
    RETENTION_COUNT_7D      NUMBER,
    SCAN_SUM                NUMBER,
    FINAL_PLAN_SIGN_DATE    DATE,
    NEED_SIGN_COUNT         NUMBER,
    STAFF_CODE              NVARCHAR2(100),
    STAFF_NAME              NVARCHAR2(100),
    POSITION_NAME           NVARCHAR2(100),
    VIRT_CODE               NVARCHAR2(100),
    VIRT_NAME               NVARCHAR2(100),
    DATE_TIME               NVARCHAR2(100),
    END_CITY_ID             NVARCHAR2(100),
    END_CITY_NAME           NVARCHAR2(100),
    DISTRICT_CODE           NVARCHAR2(100),
    DISTRICT_DESC           NVARCHAR2(100),
    DISTRICT_ID             NVARCHAR2(100),
    FREQUENCY30             NUMBER,
    DURATION                NUMBER,
    FORFEIT                 NUMBER,
    FORFEITSUM              NUMBER,
    FORFEITSUM30            NUMBER,
    MORE_3CTN_30            NVARCHAR2(100),
    MORE_3CTN_60            NVARCHAR2(100),
    AREA_CODE               NVARCHAR2(100),
    AREA_NAME               NVARCHAR2(100),
    BUTTON_DELETE           NVARCHAR2(100),
    THREE_PRE_FLAG          NUMBER,
    FIVE_PRE_FLAG           NUMBER,
    SEVEN_PRE_FLAG          NUMBER,
    YALI_FLAG               NUMBER,
    ZERO_FLAG               NUMBER,
    UPDATE_TIME             DATE
);


COMMENT ON TABLE DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE IS '爆仓告警同步oracle';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FINAL_SIGN_NETWORK_CODE IS '派件网点编码';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FINAL_SIGN_NETWORK_NAME IS '派件网点名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.END_AGENT_CODE IS '所属代理区编码';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.END_AGENT_NAME IS '所属代理区名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.END_PROVIDER_ID IS '所属省份ID';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.END_PROVIDER_NAME IS '所属省份名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.NEED_SIGN_COUNT_1D IS '1天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.RETENTION_COUNT_1D IS '1天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.NEED_SIGN_COUNT_2D IS '2天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.RETENTION_COUNT_2D IS '2天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.NEED_SIGN_COUNT_3D IS '3天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.RETENTION_COUNT_3D IS '3天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.NEED_SIGN_COUNT_5D IS '5天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.RETENTION_COUNT_5D IS '5天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.NEED_SIGN_COUNT_7D IS '7天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.RETENTION_COUNT_7D IS '7天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.SCAN_SUM IS '时效签收量';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FINAL_PLAN_SIGN_DATE IS '规划签收日期';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.NEED_SIGN_COUNT IS '零班票量';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.STAFF_CODE IS '员工编码';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.STAFF_NAME IS '员工名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.POSITION_NAME IS '岗位名称.';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.VIRT_CODE IS '虚拟代理区CODE';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.VIRT_NAME IS '虚拟代理区NAME';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.DATE_TIME IS '日期';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.END_CITY_ID IS '末端网点所属城市ID';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.END_CITY_NAME IS '末端网点所属城市名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.DISTRICT_CODE IS '转单责任网点片区CODE';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.DISTRICT_DESC IS '转单责任网点片区DESC';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.DISTRICT_ID IS '转单责任网点片区ID';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FREQUENCY30 IS '30天内爆仓天数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.DURATION IS '60天内持续天数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FORFEIT IS '当日罚金';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FORFEITSUM IS '累计罚款金额';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FORFEITSUM30 IS '30天内累计罚金';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.MORE_3CTN_30 IS '30天内连续大于等于3的次数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.MORE_3CTN_60 IS '60天内连续大于等于3的次数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.AREA_CODE IS '区域CODE';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.AREA_NAME IS '区域名字';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.THREE_PRE_FLAG IS '3日判断1是0否';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.FIVE_PRE_FLAG IS '5日判断1是0否';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.SEVEN_PRE_FLAG IS '7日判断1是0否';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.YALI_FLAG IS '压力判断1爆仓0不是';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.ZERO_FLAG IS '零班判断1不是0爆仓';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE.UPDATE_TIME IS '更新时间';



CREATE TABLE DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP
(
    FINAL_SIGN_NETWORK_CODE NVARCHAR2(100),
    FINAL_SIGN_NETWORK_NAME NVARCHAR2(100),
    END_AGENT_CODE          NVARCHAR2(100),
    END_AGENT_NAME          NVARCHAR2(100),
    END_PROVIDER_ID         NVARCHAR2(100),
    END_PROVIDER_NAME       NVARCHAR2(100),
    NEED_SIGN_COUNT_1D      NUMBER,
    RETENTION_COUNT_1D      NUMBER,
    NEED_SIGN_COUNT_2D      NUMBER,
    RETENTION_COUNT_2D      NUMBER,
    NEED_SIGN_COUNT_3D      NUMBER,
    RETENTION_COUNT_3D      NUMBER,
    NEED_SIGN_COUNT_5D      NUMBER,
    RETENTION_COUNT_5D      NUMBER,
    NEED_SIGN_COUNT_7D      NUMBER,
    RETENTION_COUNT_7D      NUMBER,
    SCAN_SUM                NUMBER,
    FINAL_PLAN_SIGN_DATE    DATE,
    NEED_SIGN_COUNT         NUMBER,
    STAFF_CODE              NVARCHAR2(100),
    STAFF_NAME              NVARCHAR2(100),
    POSITION_NAME           NVARCHAR2(100),
    VIRT_CODE               NVARCHAR2(100),
    VIRT_NAME               NVARCHAR2(100),
    DATE_TIME               NVARCHAR2(100),
    END_CITY_ID             NVARCHAR2(100),
    END_CITY_NAME           NVARCHAR2(100),
    DISTRICT_CODE           NVARCHAR2(100),
    DISTRICT_DESC           NVARCHAR2(100),
    DISTRICT_ID             NVARCHAR2(100),
    FREQUENCY30             NUMBER,
    DURATION                NUMBER,
    FORFEIT                 NUMBER,
    FORFEITSUM              NUMBER,
    FORFEITSUM30            NUMBER,
    MORE_3CTN_30            NVARCHAR2(100),
    MORE_3CTN_60            NVARCHAR2(100),
    AREA_CODE               NVARCHAR2(100),
    AREA_NAME               NVARCHAR2(100),
    BUTTON_DELETE           NVARCHAR2(100),
    THREE_PRE_FLAG          NUMBER,
    FIVE_PRE_FLAG           NUMBER,
    SEVEN_PRE_FLAG          NUMBER,
    YALI_FLAG               NUMBER,
    ZERO_FLAG               NUMBER,
    UPDATE_TIME             DATE
);


COMMENT ON TABLE DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP IS '爆仓告警同步oracle';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FINAL_SIGN_NETWORK_CODE IS '派件网点编码';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FINAL_SIGN_NETWORK_NAME IS '派件网点名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.END_AGENT_CODE IS '所属代理区编码';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.END_AGENT_NAME IS '所属代理区名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.END_PROVIDER_ID IS '所属省份ID';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.END_PROVIDER_NAME IS '所属省份名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.NEED_SIGN_COUNT_1D IS '1天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.RETENTION_COUNT_1D IS '1天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.NEED_SIGN_COUNT_2D IS '2天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.RETENTION_COUNT_2D IS '2天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.NEED_SIGN_COUNT_3D IS '3天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.RETENTION_COUNT_3D IS '3天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.NEED_SIGN_COUNT_5D IS '5天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.RETENTION_COUNT_5D IS '5天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.NEED_SIGN_COUNT_7D IS '7天应签收';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.RETENTION_COUNT_7D IS '7天内滞留';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.SCAN_SUM IS '时效签收量';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FINAL_PLAN_SIGN_DATE IS '规划签收日期';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.NEED_SIGN_COUNT IS '零班票量';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.STAFF_CODE IS '员工编码';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.STAFF_NAME IS '员工名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.POSITION_NAME IS '岗位名称.';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.VIRT_CODE IS '虚拟代理区CODE';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.VIRT_NAME IS '虚拟代理区NAME';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.DATE_TIME IS '日期';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.END_CITY_ID IS '末端网点所属城市ID';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.END_CITY_NAME IS '末端网点所属城市名称';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.DISTRICT_CODE IS '转单责任网点片区CODE';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.DISTRICT_DESC IS '转单责任网点片区DESC';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.DISTRICT_ID IS '转单责任网点片区ID';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FREQUENCY30 IS '30天内爆仓天数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.DURATION IS '60天内持续天数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FORFEIT IS '当日罚金';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FORFEITSUM IS '累计罚款金额';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FORFEITSUM30 IS '30天内累计罚金';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.MORE_3CTN_30 IS '30天内连续大于等于3的次数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.MORE_3CTN_60 IS '60天内连续大于等于3的次数';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.AREA_CODE IS '区域CODE';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.AREA_NAME IS '区域名字';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.THREE_PRE_FLAG IS '3日判断1是0否';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.FIVE_PRE_FLAG IS '5日判断1是0否';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.SEVEN_PRE_FLAG IS '7日判断1是0否';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.YALI_FLAG IS '压力判断1爆仓0不是';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.ZERO_FLAG IS '零班判断1不是0爆仓';
COMMENT ON COLUMN DM_MNG_EXPLOSION_WAREHOUSE_NETWORK_PUNISH_DT_2ORACLE_TMP.UPDATE_TIME IS '更新时间';